Index provides a faster access path to table data. It is created using one or more columns of a table to speed SQL statement execution on that table.
Table indexes are managed on the Indexes tab of the Table Designer. Just simply click/double-click an index field for editing. By using the toolbar below, allowing you to create new, edit and delete the selected index field.
Add Index
To add a table index
- Open the table in the Table Designer.
- Open the Indexes tab.
- Click the
Add Index from the toolbar.
- Edit index properties.
Edit Index
To edit a table index
- Open the table in the Table Designer.
- Open the Indexes tab.
- Click on the index to edit.
Delete Index
To delete a table index
- Open the table in the Table Designer.
- Open the Indexes tab.
- Click the
Delete Index from the toolbar.
- Confirm deleting in the dialog window.
See also:
Setting Index Properties